🎖️GitЯра🎖️
Node / meshtastic / Meshtastic-Android / files / app / src / main / java / com / geeksville / mesh / database / dao / PacketDao.kt
Displaying Raw • Download
app/src/main/java/com/geeksville/mesh/database/dao/PacketDao.kt ui_message_list (be3f882f) Text, 6.77 KB
T8b949e/*
* Copyright (c) 2025 Meshtastic LLC
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program. If not, see <https://www.gnu.org/licenses/>.
*/
Tff7b72package T7ee787com.geeksville.mesh.database.dao
Tff7b72import T7ee787androidx.room.Dao
Tff7b72import T7ee787androidx.room.MapColumn
Tff7b72import T7ee787androidx.room.Query
Tff7b72import T7ee787androidx.room.Transaction
Tff7b72import T7ee787androidx.room.Update
Tff7b72import T7ee787androidx.room.Upsert
Tff7b72import T7ee787com.geeksville.mesh.DataPacket
Tff7b72import T7ee787com.geeksville.mesh.MessageStatus
Tff7b72import T7ee787com.geeksville.mesh.database.entity.ContactSettings
Tff7b72import T7ee787com.geeksville.mesh.database.entity.Packet
Tff7b72import T7ee787com.geeksville.mesh.database.entity.PacketEntity
Tff7b72import T7ee787com.geeksville.mesh.database.entity.ReactionEntity
Tff7b72import T7ee787kotlinx.coroutines.flow.Flow
Tf0883e@Dao
Tff7b72interface T56d364PacketDao Tb4b4b4{
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT * FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND port_num = :portNum
ORDER BY received_time ASC
Ta5d6ff"""
Tb4b4b4)
Tff7b72fun Td2a8ffgetAllPacketsTb4b4b4(Te6edf3portNumTb4b4b4: Tffa657IntTb4b4b4)Tb4b4b4: Te6edf3FlowTff7b72<Te6edf3ListTff7b72<Te6edf3PacketTff7b72>Tff7b72>
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT * FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND port_num = 1
ORDER BY received_time DESC
Ta5d6ff"""
Tb4b4b4)
Tff7b72fun Td2a8ffgetContactKeysTb4b4b4(Tb4b4b4)Tb4b4b4: Te6edf3FlowTff7b72<Te6edf3MapTff7b72<Tf0883e@MapColumnTb4b4b4(Te6edf3columnName Tff7b72= Ta5d6ff"Ta5d6ffcontact_keyTa5d6ff"Tb4b4b4) Tffa657StringTb4b4b4, Te6edf3PacketTff7b72>Tff7b72>
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT COUNT(*) FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND port_num = 1 AND contact_key = :contact
Ta5d6ff"""
Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffgetMessageCountTb4b4b4(Te6edf3contactTb4b4b4: Tffa657StringTb4b4b4)Tb4b4b4: Tffa657Int
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT COUNT(*) FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND port_num = 1 AND contact_key = :contact AND read = 0
Ta5d6ff"""
Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffgetUnreadCountTb4b4b4(Te6edf3contactTb4b4b4: Tffa657StringTb4b4b4)Tb4b4b4: Tffa657Int
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff UPDATE packet
SET read = 1
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND port_num = 1 AND contact_key = :contact AND read = 0 AND received_time <= :timestamp
Ta5d6ff"""
Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffclearUnreadCountTb4b4b4(Te6edf3contactTb4b4b4: Tffa657StringTb4b4b4, Te6edf3timestampTb4b4b4: Tffa657LongTb4b4b4)
Tf0883e@Upsert
Tff7b72suspend Tff7b72fun Td2a8ffinsertTb4b4b4(Te6edf3packetTb4b4b4: Te6edf3PacketTb4b4b4)
Tf0883e@Transaction
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT * FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND port_num = 1 AND contact_key = :contact
ORDER BY received_time DESC
Ta5d6ff"""
Tb4b4b4)
Tff7b72fun Td2a8ffgetMessagesFromTb4b4b4(Te6edf3contactTb4b4b4: Tffa657StringTb4b4b4)Tb4b4b4: Te6edf3FlowTff7b72<Te6edf3ListTff7b72<Te6edf3PacketEntityTff7b72>Tff7b72>
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT * FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND data = :data
Ta5d6ff"""
Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8fffindDataPacketTb4b4b4(Te6edf3dataTb4b4b4: Te6edf3DataPacketTb4b4b4)Tb4b4b4: Te6edf3Packet?
Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffDELETE FROM packet WHERE uuid in (:uuidList)Ta5d6ff"Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffdeletePacketsTb4b4b4(Te6edf3uuidListTb4b4b4: Te6edf3ListTff7b72<Tffa657LongTff7b72>Tb4b4b4)
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff DELETE FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND contact_key IN (:contactList)
Ta5d6ff"""
Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffdeleteContactsTb4b4b4(Te6edf3contactListTb4b4b4: Te6edf3ListTff7b72<Tffa657StringTff7b72>Tb4b4b4)
Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffDELETE FROM packet WHERE uuid=:uuidTa5d6ff"Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ff_deleteTb4b4b4(Te6edf3uuidTb4b4b4: Tffa657LongTb4b4b4)
Tf0883e@Transaction
Tff7b72suspend Tff7b72fun Td2a8ffdeleteTb4b4b4(Te6edf3packetTb4b4b4: Te6edf3PacketTb4b4b4) Tb4b4b4{
Te6edf3_deleteTb4b4b4(Te6edf3packetTb4b4b4.Te6edf3uuidTb4b4b4)
Tb4b4b4}
Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffSELECT packet_id FROM packet WHERE uuid IN (:uuidList)Ta5d6ff"Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffgetPacketIdsFromTb4b4b4(Te6edf3uuidListTb4b4b4: Te6edf3ListTff7b72<Tffa657LongTff7b72>Tb4b4b4)Tb4b4b4: Te6edf3ListTff7b72<Tffa657IntTff7b72>
Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffDELETE FROM reactions WHERE reply_id IN (:packetIds)Ta5d6ff"Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffdeleteReactionsTb4b4b4(Te6edf3packetIdsTb4b4b4: Te6edf3ListTff7b72<Tffa657IntTff7b72>Tb4b4b4)
Tf0883e@Transaction
Tff7b72suspend Tff7b72fun Td2a8ffdeleteMessagesTb4b4b4(Te6edf3uuidListTb4b4b4: Te6edf3ListTff7b72<Tffa657LongTff7b72>Tb4b4b4) Tb4b4b4{
Tff7b72val Te6edf3packetIds Tff7b72= Te6edf3getPacketIdsFromTb4b4b4(Te6edf3uuidListTb4b4b4)
Tff7b72if Tb4b4b4(Te6edf3packetIdsTb4b4b4.Te6edf3isNotEmptyTb4b4b4(Tb4b4b4)Tb4b4b4) Tb4b4b4{
Te6edf3deleteReactionsTb4b4b4(Te6edf3packetIdsTb4b4b4)
Tb4b4b4}
Te6edf3deletePacketsTb4b4b4(Te6edf3uuidListTb4b4b4)
Tb4b4b4}
Tf0883e@Update
Tff7b72suspend Tff7b72fun Td2a8ffupdateTb4b4b4(Te6edf3packetTb4b4b4: Te6edf3PacketTb4b4b4)
Tf0883e@Transaction
Tff7b72suspend Tff7b72fun Td2a8ffupdateMessageStatusTb4b4b4(Te6edf3dataTb4b4b4: Te6edf3DataPacketTb4b4b4, Te6edf3mTb4b4b4: Te6edf3MessageStatusTb4b4b4) Tb4b4b4{
Tff7b72val Te6edf3new Tff7b72= Te6edf3dataTb4b4b4.Te6edf3copyTb4b4b4(Te6edf3status Tff7b72= Te6edf3mTb4b4b4)
Te6edf3findDataPacketTb4b4b4(Te6edf3dataTb4b4b4)Tff7b72?.Te6edf3let Tb4b4b4{ Te6edf3updateTb4b4b4(Tffa657itTb4b4b4.Te6edf3copyTb4b4b4(Te6edf3data Tff7b72= Te6edf3newTb4b4b4)Tb4b4b4) Tb4b4b4}
Tb4b4b4}
Tf0883e@Transaction
Tff7b72suspend Tff7b72fun Td2a8ffupdateMessageIdTb4b4b4(Te6edf3dataTb4b4b4: Te6edf3DataPacketTb4b4b4, Te6edf3idTb4b4b4: Tffa657IntTb4b4b4) Tb4b4b4{
Tff7b72val Te6edf3new Tff7b72= Te6edf3dataTb4b4b4.Te6edf3copyTb4b4b4(Te6edf3id Tff7b72= Te6edf3idTb4b4b4)
Te6edf3findDataPacketTb4b4b4(Te6edf3dataTb4b4b4)Tff7b72?.Te6edf3let Tb4b4b4{ Te6edf3updateTb4b4b4(Tffa657itTb4b4b4.Te6edf3copyTb4b4b4(Te6edf3data Tff7b72= Te6edf3newTb4b4b4)Tb4b4b4) Tb4b4b4}
Tb4b4b4}
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT data FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
ORDER BY received_time ASC
Ta5d6ff"""
Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffgetDataPacketsTb4b4b4(Tb4b4b4)Tb4b4b4: Te6edf3ListTff7b72<Te6edf3DataPacketTff7b72>
Tf0883e@Transaction
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT * FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND packet_id = :requestId
ORDER BY received_time DESC
Ta5d6ff"""
Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffgetPacketByIdTb4b4b4(Te6edf3requestIdTb4b4b4: Tffa657IntTb4b4b4)Tb4b4b4: Te6edf3Packet?
Tf0883e@Transaction
Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffSELECT * FROM packet WHERE packet_id = :packetId LIMIT 1Ta5d6ff"Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffgetPacketByPacketIdTb4b4b4(Te6edf3packetIdTb4b4b4: Tffa657IntTb4b4b4)Tb4b4b4: Te6edf3PacketEntity?
Tf0883e@Transaction
Tff7b72suspend Tff7b72fun Td2a8ffgetQueuedPacketsTb4b4b4(Tb4b4b4)Tb4b4b4: Te6edf3ListTff7b72<Te6edf3DataPacketTff7b72>Tff7b72? Tff7b72=
Te6edf3getDataPacketsTb4b4b4(Tb4b4b4)Tb4b4b4.Te6edf3filter Tb4b4b4{ Tffa657itTb4b4b4.Te6edf3status Tff7b72=Tff7b72= Te6edf3MessageStatusTb4b4b4.Te6edf3QUEUED Tb4b4b4}
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT * FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND port_num = 8
ORDER BY received_time ASC
Ta5d6ff"""
Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffgetAllWaypointsTb4b4b4(Tb4b4b4)Tb4b4b4: Te6edf3ListTff7b72<Te6edf3PacketTff7b72>
Tf0883e@Transaction
Tff7b72suspend Tff7b72fun Td2a8ffdeleteWaypointTb4b4b4(Te6edf3idTb4b4b4: Tffa657IntTb4b4b4) Tb4b4b4{
Tff7b72val Te6edf3uuidList Tff7b72= Te6edf3getAllWaypointsTb4b4b4(Tb4b4b4)Tb4b4b4.Te6edf3filter Tb4b4b4{ Tffa657itTb4b4b4.Te6edf3dataTb4b4b4.Te6edf3waypointTff7b72?.Te6edf3id Tff7b72=Tff7b72= Te6edf3id Tb4b4b4}Tb4b4b4.Te6edf3map Tb4b4b4{ Tffa657itTb4b4b4.Te6edf3uuid Tb4b4b4}
Te6edf3deleteMessagesTb4b4b4(Te6edf3uuidListTb4b4b4)
Tb4b4b4}
Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffSELECT * FROM contact_settingsTa5d6ff"Tb4b4b4)
Tff7b72fun Td2a8ffgetContactSettingsTb4b4b4(Tb4b4b4)Tb4b4b4: Te6edf3FlowTff7b72<Te6edf3MapTff7b72<Tf0883e@MapColumnTb4b4b4(Te6edf3columnName Tff7b72= Ta5d6ff"Ta5d6ffcontact_keyTa5d6ff"Tb4b4b4) Tffa657StringTb4b4b4, Te6edf3ContactSettingsTff7b72>Tff7b72>
Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffSELECT * FROM contact_settings WHERE contact_key = :contactTa5d6ff"Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffgetContactSettingsTb4b4b4(Te6edf3contactTb4b4b4: Tffa657StringTb4b4b4)Tb4b4b4: Te6edf3ContactSettings?
Tf0883e@Upsert
Tff7b72suspend Tff7b72fun Td2a8ffupsertContactSettingsTb4b4b4(Te6edf3contactsTb4b4b4: Te6edf3ListTff7b72<Te6edf3ContactSettingsTff7b72>Tb4b4b4)
Tf0883e@Transaction
Tff7b72suspend Tff7b72fun Td2a8ffsetMuteUntilTb4b4b4(Te6edf3contactsTb4b4b4: Te6edf3ListTff7b72<Tffa657StringTff7b72>Tb4b4b4, Te6edf3untilTb4b4b4: Tffa657LongTb4b4b4) Tb4b4b4{
Tff7b72val Te6edf3contactList Tff7b72= Te6edf3contactsTb4b4b4.Te6edf3map Tb4b4b4{ Te6edf3contact Tff7b72-Tff7b72>
Te6edf3getContactSettingsTb4b4b4(Te6edf3contactTb4b4b4)Tff7b72?.Te6edf3copyTb4b4b4(Te6edf3muteUntil Tff7b72= Te6edf3untilTb4b4b4)
Tff7b72?: Te6edf3ContactSettingsTb4b4b4(Te6edf3contact_key Tff7b72= Te6edf3contactTb4b4b4, Te6edf3muteUntil Tff7b72= Te6edf3untilTb4b4b4)
Tb4b4b4}
Te6edf3upsertContactSettingsTb4b4b4(Te6edf3contactListTb4b4b4)
Tb4b4b4}
Tf0883e@Upsert
Tff7b72suspend Tff7b72fun Td2a8ffinsertTb4b4b4(Te6edf3reactionTb4b4b4: Te6edf3ReactionEntityTb4b4b4)
Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffDELETE FROM packetTa5d6ff"Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffdeleteAllTb4b4b4(Tb4b4b4)
Tb4b4b4}
Served by rngit 1.5.2 - Generated in 0.08s